Aside

Rmardown file

Download a PDF of this CV

Contact

R packages used



Disclaimer

The source code is available https://github.com/ainsu23/resume.

Last updated on 2021-05-21.



Main

Andrés Felipe Insuasty Ch.

I have automated processes and reports to take key decisions using R. Data analyst who wants to be a great data scientist. On my blog, I give some tips recorded from my work

Experience

Campaigns coordinator - Data Analytics

Banco Agrario de Colombia

Bogotá, Colombia

Current - 2020

  • Creator of an internal R package to manage sales campaigns in the bank.
  1. Automation of daily, weekly and monthly campaigns: Operational time reduced: 80 hours monthly
  2. Client assignment to salesforce using R package for mathematical modelling: Precission of assigment on 100% , operation time reduced: 4 hours monthly.
  3. Use of git to manage control version in the package among the team.
  • readr, readxl, dplyr, DBI, Rmarkdown, blastula, tidyverse, tidytext, ompr, sql, shiny

Business Analyst

Ajover S.A.S

Bogotá, Colombia

2020 - 2017

    1. Implementation of a Master Planning optimization model.
  1. I Developed 12 automatic reports using R
  2. Tunning ETL process trought SQL.
  • openxlsx, DBI, tidyverse, lubridate, stringr, ggplot2, Rmarkdown, mailR, sql, shiny

Process Analyst

Carvajal Tecnologia y Servicios

Cali, Colombia

2017 - 2015

  • Led 3 Analytics projects using QlickView as a BI tool: Vendor Analytics, Daily Cash Flow and Cash flow forecasting
  • openxlsx, tidyverse, ggplot2, plotly

Project Engineer

DecisionWare

Madrid, Spain

2015 - 2014

  • Support (Technical and commercial) on projects focused on improving and optimizing business processes using Operations Research, Mathematical Modelling.
  • Excel, PowerPoint

Education

MSc. Statistics and Operations Research

Universitat Politècnica de Catalunya

Barcelona, Spain

2015 - 2013

  • Focused on Operations Reasearch
  • R, SQL, AMPL,lm

B.S., Industrial Enginner

Universidad Icesi

Cali, Colombia

2012 - 2007

  • Excel, PowerPoint, AMPL, lm